BI Developer Network Community blogs

Who is online?  0 guests and 0 members
Home  »  Blogs

Communifire Blogs

Blogs RSS Feed

Blogs: Most Recent postings

DevinKnight

Creating Power Map Reporting Solutions Recording and Q&A

5 days ago by DevinKnight  -  Comments: 0  -  Views: [105]

I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014. If you weren’t you can now watch the recording here . Following each webinar I like to post a quick Q&A session for everything I was not able to answer in the allotted time. Q: Am I correct in that you need the Pro Plus version of Office 365 and not the Home or University version? Yes, that’s correct most of the Power BI features in Excel (Power Pivot, Power View, etc..) req...

Read More

DevinKnight

Bringing Power BI Q&A to your Organization Recording and Q&A

6 days ago by DevinKnight  -  Comments: 0  -  Views: [254]

I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014. If you weren’t you can now watch the recording here . Traditionally following a webinar I try to post a quick Q&A session for everything I was not able to answer in the allotted time. Q: Does Power BI require SharePoint Online or can it work with public facing on premises SharePoint? Yes, Power BI sites and Power BI Q&A are only available if you’re using SharePoi...

Read More

Anil

How to transpose rows to columns in oracle.

7 days ago by Anil  -  Comments: 0  -  Views: [166]

In some case we need to transpose the table data that means we need to change the rows value into columns, and then this blog post will be surely helpful. Let’s say we have to find out the trend of expenses of the customer or say some account no or mobile no for some few months to find out his or her behavior such as we have a data in table ‘ Pivot_Table’ as MobileNO TotalExpenses Date 1 3000 20140101 2 5000 20140101 3 7000 20140101 1 5000 20140201 3 9000 20140201 2 3000 201402...

Read More

KathiKellenberger

SSIS 2012 Deployment Webinar followup

18 days ago by KathiKellenberger  -  Comments: 0  -  Views: [236]

You can find my followup for the webinar here .

Read More

KathiKellenberger

Where did I go?

20 days ago by KathiKellenberger  -  Comments: 0  -  Views: [213]

You may be wondering why I haven't posted here for a few weeks. I decided to move over to my own Wordpress blog: http://auntkathisql.com . I will be slowly moving my favorite posts from this blog over to the new one. Please check out my new blogging home!

Read More

DevinKnight

Upcoming Webinar – Creating Power Map Reporting Solutions

3/20/2014 by DevinKnight  -  Comments: 0  -  Views: [349]

Come join me for this webinar on 4/17/2014 at 11:00 AM EST Creating Power Map Reporting Solutions Excel 2013 with Office 365 brings many new features to the realm of Self-Service BI. There are now new ways to extract, model and present data all within Excel. One of these newest ways to present data is called Power Map. Power Map allows you to create engaging 3D map visualizations to help understand your geographical data better. This session will walk you through the beginning to end process of ...

Read More

DevinKnight

Upcoming Webinar – Bringing Power BI Q&A to your Organization

3/18/2014 by DevinKnight  -  Comments: 0  -  Views: [785]

Come join me for this webinar on 4/15/2014 at 11:00 AM EST Bringing Power BI Q&A to your Organization Q&A is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of Q&A from the Power BI site. Re...

Read More

DevinKnight

Introduction to Power BI Recording and Q&A

3/18/2014 by DevinKnight  -  Comments: 0  -  Views: [311]

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If you weren’t you can now download the recording and slides . I usually like to post follow up questions and answer that I wasn’t able to address during the webinar. Here’s several that may help you! Q: Can you explain quickly how to use Power View on SharePoint 2010? To use these together you must have SharePoint 2010 SP1 Enterprise and SQL Server 2012 Enterprise or BI...

Read More

KathiKellenberger

T-SQL Window Function Performance webinar follow up

3/14/2014 by KathiKellenberger  -  Comments: 2  -  Views: [657]

I gave a presentation this week on T-SQL Window Function Performance. You can view the presentation here . You can also download the code and the slides . I had just a couple of questions during this presentation. If you watch the recording and have a question, be sure to post the question as a comment, and I'll be sure to answer it here. Q. Please explain how to determine which columns should be used in the POC index. A. The "P" stands for Partition. If you are using a Partition By clause, then...

Read More

KathiKellenberger

My speaking schedule

3/13/2014 by KathiKellenberger  -  Comments: 2  -  Views: [377]

I love speaking about SQL Server, and I have submitted to several SQL Saturdays and events. If you would like for me to speak at your user group, especially remotely, please leave me a comment here. Here is the my speaking schedule for this year so far. I hope to see you at one of these events! Event Location Date Presentation The Greater Midwest SQL Relay St. Louis February 22, 2014 T-SQL Window Functions T-SQL WIndow Function Performance SQL Saturday #279 Phoenix March 29, 2014 T-SQL Window Fu...

Read More

KathiKellenberger

How Does the Nested Loop Operator Work?

3/13/2014 by KathiKellenberger  -  Comments: 0  -  Views: [290]

Last week I posted a blog that explained when each type of join operator will be used with an INNER JOIN. This week, I would like to describe how one of the join operators, Nested Loop, works. In programming, you can create loops that iterate through a collection or while a condition is true. You can also nest one loop inside another. When this happens, the inner loop will complete one time for every iteration of the outer loop. This is how a nested loop operation works as well. For the nested l...

Read More

DustinRyan

Do You Know Why Your MDX Query Is Slow?

3/7/2014 by DustinRyan  -  Comments: 0  -  Views: [762]

Performance tuning MDX queries can often be a daunting and challenging task. But the first step in deciding where to begin your efforts to improve the performance of your query is to diagnose the source of the problem. There are two areas that could be causing our performance issue: 1. The design of our SSAS solution or 2. The design of our query. We need to figure out if we?ve written a bad query or designed a bad cube :). How Do We Test The Query? Usually an issue is discovered when a user com...

Read More

KathiKellenberger

Which Join Operator Will My Query Use?

3/7/2014 by KathiKellenberger  -  Comments: 2  -  Views: [303]

There is so much to learn about SQL Server that I am both enthusiastic and overwhelmed when I think about it. Of course, depending on what an individual likes to do, some things will be easier for them. For example, I would trust Itzik Ben Gan with my life if it depended on writing a T-SQL query. But I wouldn’t expect him to be the same level of guru on SSIS or SSAS. (Maybe I am wrong here; he is brilliant and might be an expert on those technologies, too.) For me, the joy of working with ...

Read More

Neeraj

HR Analytics: An effective utilization

3/5/2014 by Neeraj  -  Comments: 0  -  Views: [380]

HR Analytics is all about providing workforce information to business leaders so they can attract, develop, and retain the best people. It enables HR leaders to see the business outcomes of the processes and initiatives. Organizations spend hundreds of dollars on employees and are willing to invest in people but most of the time they lack data to justify its worth or are in possession of incorrect data. The investments made are not able to show quantifiable results in the field of HR analytics i...

Read More

DevinKnight

Upcoming Webinar - Introduction to Power BI

2/28/2014 by DevinKnight  -  Comments: 3  -  Views: [529]

Come join me for this webinar on 3/13/2014 at 11:00 AM EST Introduction to Power BI The future of Business Intelligence has many new and exciting features. This world that was once reserved for only experts in SQL Server technologies has expanded to serve the masses with more and more self-service innovations. In this session you will gain an understanding of what Power BI is and get an overview of each of the components. This includes Power Pivot, Power View, Power Query and Power Map, Mobile P...

Read More

KathiKellenberger

Using a window aggregate function in an aggregate query

2/27/2014 by KathiKellenberger  -  Comments: 0  -  Views: [669]

A window aggregate function is an easy way to perform an aggregate calculation without changing the query to an aggregate query. This means that you can calculate an aggregate over the entire dataset while keeping the detail in the results. You can also perform calculations on smaller windows, or partitions, of the data. Here is a query that provides an overall total, a total for each customer, and the average sale for each customer. Even though the query is returning sums and an average, the de...

Read More

TMMichau

Filtering inside of Monitoring Console

2/25/2014 by TMMichau  -  Comments: 2  -  Views: [225]

So you want to look at a particular package in the monitoring console of BIxPress, but when you open the monitoring console you see every iteration of all the packages you have ran (according to your option settings). So how do you filter this down to just a particular package? Though the options, let me walk you through it. 1. Open the Monitoring Console inside the workbench. 2. Click on the options button 3.This opens the option window. 4. When you click on the bar that says"Click here to add ...

Read More

KathiKellenberger

Have you made it? A question from SQL Saturday #241

2/21/2014 by KathiKellenberger  -  Comments: 1  -  Views: [791]

I spent last weekend attending the SQL Saturday in Cleveland . The event was held at Hyland Software , a company with sliding boards and pool tables for their staff. It was a very nice venue and the Cleveland SQL Saturday team did a great job. One of the reasons I wanted to attend is the chance to visit the Rock and Roll Hall of Fame . I have visited Cleveland one other time several years ago, but wasn’t able to visit the museum. I went along to the museum with Tim Radney who also arrived ...

Read More

CraigLove

SQL Server Firewall Settings - Part 3

2/20/2014 by CraigLove  -  Comments: 0  -  Views: [488]

This is the 3 rd part of my series of blog posts I am writing regarding configuring firewalls to permit connections to SQL Server services. In Part 1 , I reviewed ope n ing the port for the default instance of the SQL Server relational database engine. In Part 2 , I covered how to set the static port for named SQL Server relational database instances and also how to configure the SQL Browser service to permit connections using the named instance. In this blog post I will review the firewall sett...

Read More

DevinKnight

Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A

2/17/2014 by DevinKnight  -  Comments: 0  -  Views: [1356]

I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on February 11, 2014 that I delivered with Dustin Ryan . If you weren’t you can now watch the recording here . Traditionally following a webinar I try to post a quick Q&A session for everything I was not able to answer in the allotted time. Q: Since Tabular solutions are many ways better than Multidimensional..then my question is when to go for Multidimensional solution You would l...

Read More

DevinKnight

Power BI for Office 365 Released

2/10/2014 by DevinKnight  -  Comments: 0  -  Views: [622]

Today Microsoft has officially announced the release of Power BI for Office 365. You can read the Power BI teams post on the release here: http://blogs.msdn.com/b/powerbi/archive/2014/02/10/announcing-the-general-availability-of-power-bi-for-office-365.aspx Power BI has some pretty amazing features that allow users take control of their data. I’ve also written several posts in the past about the Power BI features you can browse here: Power Pivot PowerPivot – Creating KPIs PowerPivot ...

Read More

KathiKellenberger

T-SQL Window Functions webinar follow up

2/6/2014 by KathiKellenberger  -  Comments: 0  -  Views: [398]

For those of you who attended my presentation on Feb. 4th, thank you so much! Here is the recording if you missed it or would like to watch it again. Here are the slides and code . I received a number of questions during the session which I will also answer here: Q. Any big changes in 2014 in regards to windowing functions. A. I am sad to say that there are no changes to window functions in 2014 unless Microsoft gives us a last minute surprise. Q. For the percentile rank function, how does the f...

Read More

Anil

Watch 24 Hours of PASS Business Analytics sessions if you had missed any.

2/6/2014 by Anil  -  Comments: 0  -  Views: [717]

From yesterday evening to till today morning I had a great time attending the ‘ 24 Hour of PASS: Business Analytics ’ free live 12 back-to-back webcasts from various BA Conference speakers. If you have missed out to join the live sessions on 5th Feb 2014 th which had begin at 08:00PT / 11:00 ET / 16:00 GMT , then no worries the recorded webcasts sessions is available now and you can just check out those great session and am sure you will get some great knowledge in the world of BA fr...

Read More

DevinKnight

Final Day for Power BI Voting, Can I Have Your?

1/30/2014 by DevinKnight  -  Comments: 0  -  Views: [472]

Today is the final day for the Power BI Contest voting and I could use your help to move on in the competition! Please take a moment and vote for my video here http://tinyurl.com/PowerBIDevin Thanks for voting!

Read More

CraigLove

(Repost) Dimension Attribute Relationships – Rigid vs. Flexible

1/28/2014 by CraigLove  -  Comments: 1  -  Views: [907]

As a consultant for PragmaticWorks, I work with a lot of different people. I have noticed that there is a lot of confusion about dimension attribute relationships with SQL Server Analysis Services Multidimensional databases. This posting is explores flexible and rigid attribute relationships and the impact each of these have on incremental processing and cube aggregations. Dimension Relationships First, let’s define what a dimension attribute relationship is. Attribute relationships provid...

Read More