print logo

Expert Blog: Resources for BI and Excel

Published: 6/18/2018 Author: Brian Wallace

At Kiefer, we are proud of the skills and talents of our team. One of the things that sets our team apart is their eagerness and willingness to learn new skills. As a Microsoft Partner, we must continually reinvest in our staff to ensure they have the skills required to successfully deliver projects. Also, we must make sure we have the skills required by Microsoft in order to keep our Microsoft competencies up to date.

As a company, Kiefer is committed to keeping our team members current on their skills. We pay for employees to take Microsoft exams and we also give our employees time off to prepare for tests. Beyond the company's investment in our employees, we also learned that our employees do a lot on their own as it relates to staying sharp on technology, best practices, and related skills.

This month, we are happy to introduce our new Expert Blog Series. We have interviewed our consultants and asked them to share the tools and resources that they look to for staying ahead in a rapidly changing industry. We were able to learn more about where the pros go for information and the communities that they look to in order to stay at the top of the game.

With a team of 20 talented consultants, we have a wide range of expertise distributed across the team. It's unrealistic to think that you could have a single resource that has the depth and knowledge that we have spread out over the Kiefer team. We count on specific people on the team for specific know-how.


This month, we profile consultant, Scott Roberts. Scott has become the team's go-to resource for business intelligence and reporting. Scott cut his teeth on Excel and was really good at finding ways to leverage the product to deliver insights and has been successful in enabling clients to do more with the data.


Scott has represented Kiefer at the Microsoft Data Insights Summit and has presented on Kiefer's behalf at SharePoint User Group meetings. He's a knowledgeable resource and has helped Kiefer in maturing the Business Intelligence practice area.

Here are a few of the resources that Scott looks to. These resources are valuable if you are into business intelligence, Excel, SSRS, and SQL.

1.      Power Pivot Pro (https://powerpivotpro.com/)

If you follow Kiefer, you might have seen that we presented Power BI at a SharePoint User Group Breakfast a while back. It was cool to deliver a business intelligence presentation to a room full of SharePoint enthusiasts. We were surprised that attendees were so interested in Power BI and found that attendees wanted Scott to share the resources he would recommend for learning more about business intelligence.

One of Scott's trusted resources for Power Pivot and Power BI is Power Pivot Pro. Power Pivot Pro has both a blog and a book (Power Pivot and Power BI). Scott carries the book around everywhere and he's recommended both the book and website to a lot of people. He talked about the book at SharePoint Breakfast and has suggested that anyone interested in BI should get a copy of the book.


2.      Chandoo (www.chandoo.org)

We all know that you can do a lot in Excel. The tagline of chandoo.org reads, "Become Awesome in Excel". The blog author, Chandoo, provides Excel & Power BI tutorials, examples, tips, videos and articles on the chandoo.org website. He offers a fantastic blog that covers a range of interesting BI and Excel related topics. In fact, his recent blog about the best Power BI / Excel books of 2018 (https://chandoo.org/wp/best-excel-power-bi-books/) mentions the Power Pivot and Power BI book that we mentioned in this blog!

Also, check out the "Excel Formulas" page. Very cool info for Excel users! https://chandoo.org/excel-formulas/index.shtml


3.      SQLBI (www.sqlbi.com)

The team over at sqlbi.com knows their stuff! They write excellent articles and white papers that dive deep into Microsoft Business Intelligence technologies. You'll also find that SQLBI has written a number of books that we consider essential reading if you are a BI professional. Many of their books are published by Microsoft Press, such as Analyzing Data with Power BI and Power Pivot for Excel, Tabular Modeling in SQL Server Analysis Services (2nd Edition), and Introducing Microsoft Power BI. We think they have a lot of great resources and encourage you to check out their blogs and their books!


If you are looking for an expert in Power BI, Excel or SQL, please reach out. We have a trusted team with deep expertise in helping organizations do more with data. Contact Kiefer to talk to our team. Call us at (916) 932-7220.

Look for our Expert Blog next month! We'll be sharing more awesome resources.

 

 

 

 

 

 

12 Gifts-Gift Number 3-Sending links instead of fileshttps://www.kieferconsulting.com/BlogPosts/Pages/12-Gifts-Gift-Number-3-Sending-links-instead-of-files.aspx12 Gifts-Gift Number 3-Sending links instead of files
12 Gifts-Gift Number 2-Outlook shortcuts you can use every dayhttps://www.kieferconsulting.com/BlogPosts/Pages/12-Gifts-Gift-Number-2-Outlook-shortcuts-you-can-use-every-day.aspx12 Gifts-Gift Number 2-Outlook shortcuts you can use every day
12 Gifts-Gift Number 1-Drag and Drop in Outlookhttps://www.kieferconsulting.com/BlogPosts/Pages/12-Gifts-Gift-Number-1-Drag-and-Drop-in-Outlook.aspx12 Gifts-Gift Number 1-Drag and Drop in Outlook
Go with the Flow. An introduction to Microsoft Flow.https://www.kieferconsulting.com/BlogPosts/Pages/Go-with-the-Flow--An-introduction-to-Microsoft-Flow.aspxGo with the Flow. An introduction to Microsoft Flow.
Microsoft Teams is Coming to the Government Cloud. Our Predictions.https://www.kieferconsulting.com/BlogPosts/Pages/Microsoft-Teams-is-Coming-to-the-Government-Cloud--Our-Predictions.aspxMicrosoft Teams is Coming to the Government Cloud. Our Predictions.

 Recent Posts

CT Blog Post