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

Communifire Blogs

Blogs RSS Feed

DevinKnight : Most Recent postings

DevinKnight

Creating Power Map Reporting Solutions Recording and Q&A

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

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

7 days ago by DevinKnight  -  Comments: 0  -  Views: [283]

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

DevinKnight

Upcoming Webinar – Creating Power Map Reporting Solutions

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

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: [806]

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: [315]

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

DevinKnight

Upcoming Webinar - Introduction to Power BI

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

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

DevinKnight

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

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

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: [624]

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

DevinKnight

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

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

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

DevinKnight

Power BI Contest Entry Voting

1/20/2014 by DevinKnight  -  Comments: 0  -  Views: [794]

You’ve watched my video (hopefully) now vote for it! In a previous post I wrote about my Power BI contest entry (Read more about it here ). I really enjoyed making this video and hopefully you enjoyed watching it. Please take a few moments and vote for my entry here. http://j.mp/1cFcLGj

Read More

DevinKnight

Power BI Contest Entry

1/8/2014 by DevinKnight  -  Comments: 1  -  Views: [966]

Today I submitted my Power BI contest entry and I’d love for you to take a look! Here’s a short description of entry and the video itself: In this submission I have used Power BI to help me plan a vacation with my wife. We both love thrill rides so I wanted to make the best decision on planning our next trip. Using Power Query I imported data from the web to find all possible roller coasters and amusement parks. I then took that raw data and made relationships and calculations using ...

Read More

DevinKnight

Power BI Q&A Preview Now Live On Your Data

12/18/2013 by DevinKnight  -  Comments: 0  -  Views: [1504]

With the recent updates to the Power BI preview and Q&A features added I thought I would do a quick tutorial of how it all works. This post will walk you through uploading a workbook to Power BI, Using Q&A against that workbook, enhancing the workbook with synonyms and the creating features questions. First, sign up for a trial at www.PowerBI.com . Once your trial Power BI site has been issued to you login and add your own Power Pivot workbook by selecting Add as shown below. After you a...

Read More

DevinKnight

Using Power Query to Parse your Inbox

12/13/2013 by DevinKnight  -  Comments: 0  -  Views: [1683]

One of the nice new features that was added to Power Query with the latest update in December is the ability to connect to Microsoft Exchange as a data source. You can download this update now here: http://www.microsoft.com/en-ca/download/details.aspx?id=39933 Here’s a quick demonstration of how you may use the Microsoft Exchange data source in a Power BI solution: After downloading and installing Power Query launch Excel and navigate to the Power Query tab. If you don’t see the Powe...

Read More

DevinKnight

Thoughts on December 2013 Power Query Updates

12/11/2013 by DevinKnight  -  Comments: 0  -  Views: [909]

Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The list of updates can be found here but for my notes specifically on Power Query updates continue reading! Power Query Power Query now has 3 new data sources that you can connect to. Connectors have now been added for Sybase IQ, Exchange and Dynamics CRM Online. Sybase IQ is the column-store database technology produced by SAP and is used for many organizations for BI solutions. This...

Read More

DevinKnight

Power Pivot Synonyms

11/19/2013 by DevinKnight  -  Comments: 0  -  Views: [2337]

A little gem was included with the latest Office 365 update. After downloading and installing this update you will now find that a feature called Synonyms is available inside Power Pivot. Synonyms are a piece of the puzzle that make the Power BI feature Q&A work. If you haven’t seen Q&A watch these two videos and sign up for the Power BI preview yourself. http://blogs.msdn.com/b/pedram/archive/2013/07/16/the-natural-language-capability-of-power-bi.aspx http://blogs.msdn.com/b/micro...

Read More

DevinKnight

New Book: Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services

11/14/2013 by DevinKnight  -  Comments: 0  -  Views: [3159]

I’m very excited to announce that you can now purchase my latest book: Building Performance Dashboards and Balanced Scorecards with SQL Server Reporting Services . This booked, offered by Wiley , takes you through designing effective balanced scorecards using Reporting Services. You can get your copy of my new book here !

Read More

DevinKnight

Dealing with Power Pivot to Tabular Upgrade Errors

11/4/2013 by DevinKnight  -  Comments: 0  -  Views: [1822]

Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the beauty of the relationship between Tabular and Power Pivot. This allows an Analyst to get started on a project using Power Pivot and when new requirements like row level security are needed IT can upgrade the workbook to Tabular and add the security feature. While this generally is a smooth process I often see the same couple error messages pop up for folks that are doing this. S...

Read More

DevinKnight

PASS Summit 2013 and SQL Saturday Charlotte in Review

10/21/2013 by DevinKnight  -  Comments: 0  -  Views: [1490]

I love reading the many blogs posts that pour in following a PASS Summit. I think it is fun to read everyone’s experience. There’s not really a wrong way to attend the conference unless you just hide our in your hotel the whole week. Here’s how my week went. Sunday This was a travel day for me. I drove with Brad Schacht and Gareth Swanepoel up to Charlotte from Jacksonville. This was a fun 5.5 hour drive as Gareth live tweeted our trip with the hashtag #sqlwolfpack. We arrived ...

Read More

DevinKnight

Awarded Microsoft MVP

10/1/2013 by DevinKnight  -  Comments: 3  -  Views: [1189]

Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first time. Becoming an MVP has been an informal goal for me for quite sometime now. I’ve always kept this as more of an informal goal because I’ve always thought of myself as someone that does the right thing when no one is looking. In fact, this is something I work on constantly with my oldest son because it is that important to me. My end goal with being involved i...

Read More

DevinKnight

Understanding Microsoft Self-Service BI Recording and Q&A

9/26/2013 by DevinKnight  -  Comments: 0  -  Views: [1641]

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If you weren’t you can now download the recording here . Because I covered new material all the way to the end of the webinar i thought I’d also answer some of the top questions I didn’t have time to answer here. Q: Can an Excel Power Pivot 2013 model be read by Excel 2010 or Excel 2007? What about Excel versions and their compatibility with SharePoint Versions? I as...

Read More

DevinKnight

Power Map Enhancements and Presentation

9/20/2013 by DevinKnight  -  Comments: 0  -  Views: [1327]

Power Map for Excel 2013 has had some recent enhancements that are worth noting. You can download the latest Power Map install file here . This update includes some really nice features that are helping make Power Map consumable to a larger audience. Here’s a quick list of some of the biggest enhancements you will find: Can now handle hidden and calculated fields from Power Pivot model Regions for geopolitical boundaries Export tours to .mp4 videos for sharing Customized colors for layers ...

Read More

DevinKnight

Introduction to Power Query Q&A

8/28/2013 by DevinKnight  -  Comments: 0  -  Views: [1876]

Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013. If you were not able join for the live event you can now watch the recording here . This was part of an ongoing webinar series by Pragmatic Works offers every Tuesday and Thursday at 11:00 AM EST. In this webinar we showed several examples of how Power Query can be used as an effective Self-Service ETL tool. I discussed that enterprise level ETL tools like SSIS are not going anywhere, but that Power...

Read More

DevinKnight

Whitepaper: Building Self-Service BI Solutions with Power Query

8/24/2013 by DevinKnight  -  Comments: 0  -  Views: [2358]

Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate than any traditional BI solution. This is why businesses are looking to Self-Service BI to solve the smaller, but no less significant, problems that individual departments need addressed. The goal of this white paper is to focus on using and understanding one of Microsoft’s latest Self-Service BI tools called Power Query. Download the Whitepaper now!

Read More

DevinKnight

Extracting Data From Multiple Files with Power Query

8/13/2013 by DevinKnight  -  Comments: 0  -  Views: [1512]

In this post I’d like to demonstrate another way Power Query can solve simple data extraction problems without much time or effort. If you’re still learning the basics of Power Query please refer back to an earlier post here . This demonstration will show you how to use Power Query to scan a file folder to search for a set of files to load. Then load the contents of multiple files all at once and use transformations to format the data appropriately.. Step by Step Launch Excel 2010 or...

Read More

DevinKnight

Using Parameters in Power Query Extracts

8/7/2013 by DevinKnight  -  Comments: 0  -  Views: [2887]

Introduction By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have heard of the tool many still have not gotten their hands on it and started experiencing the potential it has. In case you’re new to Power Query here’s a couple quick points before continuing on: It is a self-service ETL (Extract Transform Load) Tool built on top of Excel It is an add-in available for Excel 2010 or 2013 Download it here . Getting Started with Micr...

Read More