Tag Archives: Reports

Teradata Reports Better Than Expected 2017 Third Quarter Results

Download PDF
Teradata United States

Teradata Reports Better Than Expected 2017 Third Quarter Results

Download PDF
Teradata United States

How to Create Custom Test Execution Reports in Excel from Team Foundation Server – Part 1

Team Foundation Server (TFS) is a Microsoft product which provides source code management, project management, reporting, release management and testing. TFS has a lot of inbuilt reporting and dashboard services available. By connecting TFS to Microsoft Excel, we can use different functionalities of Excel to extend reporting capabilities and be more flexible with creating test execution reports. It is also excellent for users that are more comfortable and familiar with Excel.

The first step to this is setting up queries in TFS. Queries are the basic building blocks for managing work items. For testers generating custom test execution reports, we would be more concerned with TFS Bugs. Queries allow us to filter work items in TFS to be transported to Excel for data sorting, visualization, etc. It is also easier to update queries when work items also change. For example, a bug changes its state depending on the test lifecycle. This could mean that the bug gets removed from an Active Bugs query and gets added to a Closed Bugs query. Queries can simply be refreshed in TFS, which gets updated dynamically in our Excel spreadsheet when clicking the Refresh button under the TEAM tab.

How a user would log and label bugs (using TFS field Title) and group these bugs (using TFS fields e.g. Tag, State, Severity, Assigned To) would determine how bugs are sorted into different queries configured by the user. In this example below, I’ve grouped all my Active Bugs in TFS via the State.

image thumb 4 How to Create Custom Test Execution Reports in Excel from Team Foundation Server   Part 1

The bugs that are logged for this subcomponent in a TFS Team Project must obviously contain these filter criteria to appear under the query. This is entirely up to how the user would set up the query. Below is an example on how I labelled the bug in TFS such that it meets the conditions of the example query. This is done by including a Tag called ‘CRM’ and prefixing the Work Item Title with ‘[Magnetism Sub Group]’.

image thumb 6 How to Create Custom Test Execution Reports in Excel from Team Foundation Server   Part 1

You can be creative in what Work Item fields you are using to differentiate different queries. This added flexibility in TFS allows the user to further modularise different queries. Once I run the example query, this work item gets brought under the query results.

image thumb 7 How to Create Custom Test Execution Reports in Excel from Team Foundation Server   Part 1

Once we can effectively separate and group each different bug accordingly in TFS, we need to establish a connection between the source TFS to the destination Excel spreadsheet. The TEAM tab in Excel allows us to connect TFS with Excel such that we can create a custom report in Excel.  This automatically shows up when Team Explorer or Visual Studio is installed. If it does not show up, the TEAM tab needs to be enabled using the following steps:

  1. Go to File > Options to open Excel Options.
  2. Navigate to the Customize Ribbon.
  3. Click the TEAM checkbox. Click OK.

Once the TEAM tab is enabled in Excel, we can connect to a Team Project such that we can transport work item lists into Excel. Excel gives an option of creating two types of work item lists: query or input flat lists.

image thumb 8 How to Create Custom Test Execution Reports in Excel from Team Foundation Server   Part 1

Using our earlier example query “Active Bugs – Magnetism Sub Group Changes – CRM” and its work item components, it gets transmitted to Excel once we choose the query list. This is shown below. Note that the Refresh button highlighted gets activated once we have connected through our query list and loaded our work components.

image thumb 10 How to Create Custom Test Execution Reports in Excel from Team Foundation Server   Part 1

All done! Part 2 of this blog will cover how we can use Excel to pull in our data from TFS such that we can construct our test execution report and data visualisations.

Let’s block ads! (Why?)

Magnetism Solutions Dynamics CRM Blog

China Mobile Reports CNY62.7 Billion Net Profit For H1 2017

China Mobile published its semi-annual report for the first half of 2017, stating that the company realized operating revenue of CNY388.9 billion, a year-on-year increase of 5%; and its net profit was CNY62.7 billion, a year-on-year increase of 3.5%.

China Mobile’s communication services revenue was CNY348 billion, an increase of 6.9%. Meanwhile, its mobile Internet revenue reached CNY187.7 billion, accounting for over 50% of its total communication services revenue.

During the reporting period, China Mobile’s earnings before interest, taxes, depreciation and amortization were CNY140.7 billion, marking an increase of 4.7% compared with the same period of last year.

In regards to 4G development, China Mobile revealed in the report that the company’s number of 4G base stations reached 1.65 million during the first half of 2017. At the same time, China Mobile saw a net increase of 58.62 million 4G users, reaching a total of 594 million. Its 4G penetration rate reached 69%.

China Mobile said that they are confident in achieving their development goal for the year, which is to add 100 million 4G users in 2017.

In addition, China Mobile launched VoLTE HD voice services in 313 cities and the number of its VoLTE users reached 98.73 million.

Let’s block ads! (Why?)

ChinaWirelessNews.com

Teradata Reports 2017 Second Quarter Results

Download PDF
Teradata United States

Embedding Power BI Reports with Power BI Report Server

A common question I get is what will we will be able to do around embedding Power BI reports with Power BI report server. To understand this it is important to look at how the Power BI reports are being integrated into SSRS.

The Power BI reports are really a new type of reports supported by Reporting services. In SQL Server 2016 we added support for mobile reports and now with Power BI Report Server we add support for Power BI reports. This means that the reports will be using the traditional reporting services framework and “content management” system which means it’s existing folder structure including all it’s security features but also it’s existing embedding framework. Now SSRS has several ways to do embedding, one is using the reportviewer control and the other is through iframe embedding. The report viewer control only works for RDL files, not for the mobile reports nor for the Power BI reports, that leaves us with the traditional IFrame embedding.  Let’s take a look at this works.

To try this I started by creating a sample report and upload it to Power BI report server:

 Embedding Power BI Reports with Power BI Report Server

This I can open and see as part of my Report Server:

 Embedding Power BI Reports with Power BI Report Server

Now let’s say I want to embed this into a regular ASP.NET application. I start by creating a blank ASP.NET web app in Visual Studio and remove all the content from my Default.ASPX  within the asp:Content tags and replace it with an asp.net Iframe, leaving my page to look like this:

<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<IFRAME id="frame1" scrolling="auto" runat="server" width="1000px;" height="600px">
</IFRAME>
</asp:Content>

Now in my code behind I want to load my report:

protected void Page_Load(object sender, EventArgs e)
{
frame1.Src = "http://kadejosb/Reports/powerbi/PBItest/pbitest";
}

Running this will compile and run but will not show anything:

 Embedding Power BI Reports with Power BI Report Server

The trick here is to add the following parameter to the URL: “?rs:Embed=true” as described here in the SSRS team blog. This will generate an embedding-optimized view of the report.

Now the code looks like this:

protected void Page_Load(object sender, EventArgs e)
{
frame1.Src = "http://kadejosb/Reports/powerbi/PBItest/pbitest?rs:Embed=true";
}

Now running this again give us what we want:

 Embedding Power BI Reports with Power BI Report Server

And that is it, of course this can be used in a customer application or when you want to embed into SharePoint.

A few interesting things to note here are:

  1. There are currently no ways to add parameters to the connection string, I talked to the team and this is definitely on the road map.
  2. The user who is connecting to your custom app also needs to have access to the Power BI report on the report server, this is great for internal applications but harder for extranet scenario’s. A solution to this is also on the road map.

Let’s block ads! (Why?)

Kasper On BI

Tech Tip Thursday: Dynamic Power BI reports using Parameters

Microsoft’s Guy in a Cube has been providing tips and tricks for Power BI and Business Intelligence on their YouTube channel since 2014. Occasionally on Thursdays we highlight a different helpful video from the collection.

Did you know that you can dynamically filter data in Power BI using parameters that are stored in an Excel workbook? In this video, Patrick from Guy in a Cube shows us how, using M Functions within Power Query and a gateway to enable data refresh. Check it out!

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Power BI Report thumb DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Guess how many articles are here on PowerPivotPro.com?  Go ahead and think of a number, I’ll wait.

The answer, at time of writing, is 923.  Rob alone has published 715 articles!  And these date all the way back to 2009.

A lot of these articles are “old,” but folks, the DAX engine is still 99% the same today in Power BI (and Excel 2016) as it was when it first “hit the shelves” in Spring 2010.

The motivation behind this “Reanimator” series, then, is twofold:

  1. Help newer converts/readers rediscover some of the most-awesome techniques previously covered here (without being so lazy as re-posting them in their original form)
  2. “Refresh” those techniques for the brave new world of Power BI (since the vast majority of old articles were written when we only had Power Pivot)

What better way to do that than to re-create those workbooks in Power BI Desktop and embed the report directly…Within. This. Post! wlEmoticon smile DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

A New Age of Self-Service BI Users

I’ve been fortunate enough to be given the honor of sharing with you, our community, all these wonderful posts written by many of our in-house industry experts. Updated in all their glory into the wonderful world of Power BI. Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire. Just as the BI gods intended them to be! My hope is that these updates will instill these tools to the growing number self-service BI users just getting into the field and who want to do AWESOME things with their reports.

Highlights From The Original Post(s)

So this update is actually a continuation of not just one…but TWO posts written by Rob in the distance past of 2012 (in technology years that’s basically forever). The two original posts were:

Dynamic TopN Reports Using PowerPivot V2!

Dynamic TopN Reports via Slicers, Part 2

Excel Report thumb DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers

Rob demos some pretty ingenious techniques using his (now prolific) disconnected slicers technique to not only control the Top N Number you’d like to see on charts or graphs, but also the Value that you want to see that Top N Number ranked on. I’ve used it in MANY reports I’ve made over the years, always impressing the customers who used them.

Now I don’t want to give too much away in this post, instead directing you back to the walkthrough via the links above. I’m just here to whet your appetite enough with some fancy Power BI Reports, and if you want to learn the DAX code, hop into Rob’s posts.

This “Picture” Below is an Interactive Power BI!

Isn’t Something Missing?

Some of our more avid blog readers may be thinking “wasn’t there a THIRD post about TopN filtering?”. Yes, in fact there was. It was written by guest contributor Colin Banfield and is called Dynamic TopN Reports via Slicers, Part 3. It’s a fantastic post which covers ways to add BottomN metrics, Month/Year slicers, and more. I chose not to use that workbook since I wanted to capture the core story from the original posts written by Rob. If you’re inclined however, I recommend reading all three as they will add real value to your DAX tool belt. Until next time P3 Nation!

Download the Files!

Download the PBIX files

X

Get Your Files

Let’s block ads! (Why?)

PowerPivotPro

Power BI + ZoomCharts = (Power BI)²: Boost your productivity and add the cool-factor to your reports

As of today, all Microsoft Power BI users can start using dynamic and cool-looking ZoomCharts in reports and dashboards.

With ZoomCharts, you can easier than ever before, explore, present and analyze your data. Full multi-touch support makes interaction seamless across all your devices.

Try it yourself with this Power BI live report to feel the difference:

How do ZoomCharts custom visuals increase your productivity with Power BI?

ZoomCharts is driving innovation in the world of charts and graphs. It’s challenging the very concept of charts by enabling the transition from static data representation to a fully interactive and dynamic user experience. Essentially, charts become alive. Interaction with the charts happens in the most natural way – with a simple click, touch, pinch or swipe. This means that datacan be analyzed and presented in a whole new way on any device. ZoomCharts claims that this approach saves time on report generation, presentation and answer seeking, turning data exploration into an engaging experience.

ZoomCharts combines analysis with presentation, making decision making easier than ever.

Three new custom visuals for data presentation and analysis

ZoomCharts has created three custom-visuals for Microsoft Power BI users:

Drill-down donut chart

Designed for exploring multi-level data in depth and across the level of interest.

Try this visual in a Power BI report and get this custom visual from the store.

Start with the overview and drill-down into details with a tap on a slice. Tap in the middle to return to previous level. “Others” slice is dynamic as well – tap to explore.
223a4112 7cf0 4a50 8cd8 bdd10b7e93bd Power BI + ZoomCharts = (Power BI)²: Boost your productivity and add the cool factor to your reports
In this example, we are looking at sales data. With drill-down you can easily see how profits group by industries, company revenue and size.

Drill-down column/line/area chart for category-based data

Designed for exploration and presentation of category-based data.

Try this visual in a Power BI report and get this custom visual& from the store.

Start with the overview and drill-down into details with a tap to expand a column or area of interest. Swipe up to return to the previous level.
8c47038a 659a 46fc 8072 5ed8c56aed48 Power BI + ZoomCharts = (Power BI)²: Boost your productivity and add the cool factor to your reports
In this example we are comparing revenue, cost and profit by product types and billing frequency.

Drill-down column/line/area chart for time-based data

Designed for exploration and presentation of time-based data.

Try this visual in a Power BI report and get this custom visual from the store.

Start with the overview and drill-down into details with a tap. Swipe up or down to zoom in and out. Swipe left or right to pan the timeline. Filter your report by selecting time range on time-axis.
01a4bc26 85ce 4acc a965 35e948b6d05b Power BI + ZoomCharts = (Power BI)²: Boost your productivity and add the cool factor to your reports

In this example we can see revenue, costs and profits by years. With a touch, you can drill down to month and day level.
 

Built for productive reports with an engaging cool-factor

As Microsoft Power BI enables filtering through charts, you can combine all three new custom visuals to create even more productive reports. Here is an example of sales data report, where you can see, explore and analyze the sales data by the selected dimensions. Selection of a specific time range in a timeline chart will filter automatically the donut and column charts by the same time range. Similarly, selection of a slice or column will filter automatically the two other charts by the chosen category.

What does this mean for businesses?

With the ever-increasing need to make business-critical decisions, users need to optimize the way they work with reports and dashboards. With the increasing popularity of mobile devices, interactive, multi-touch-ready reports and dashboards is becoming a must-have. Successful businesses are able to make better decisions faster, and ZoomCharts in Power BI enable bussiness users to do that.

What does this all mean to you?

Is ZoomCharts here to change the way we work forever? We don’t know that yet. All we know is that ZoomCharts have customers from more than 35 countries worldwide with companies among the Fortune 500.

If you want to add the cool-factor to your dashboards and double your productivity with Power BI, try the new custom visuals today! Or check them out via Microsoft Office Store.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Teradata Reports 2017 First Quarter Results

Download PDF
Teradata United States