7 Ways to Integrate Excel with Power BI

Slides from my presentation “7 Ways to Integrate Excel with Power BI”.

Power BI is gaining a momentum but Excel still rules the corporate world. Fortunately, Power BI and Excel are not exclusive choices. Join me to learn how you can preserve your Excel investment in Power BI. I’ll start by explaining the value Power BI brings to different types of users in your organization. Then, I’ll discuss and demo seven options for integrating Excel with Power BI:

  • Import Excel files in Power BI Service
  • Build self-service data models from Excel data
  • Deploy Excel models to Power BI
  • Convert Excel models to Power BI
  • Connect to Excel reports
  • Analyze Power BI datasets in Excel
  • Add Excel reports to Power BI dashboards

Embed Interactive Reports in Your Apps

Slides from my presentation for Atlanta Code Camp 2016 on Power BI Embedded.

You have the app. You have the data. What if your app could put the power of analytics everywhere decisions are made and allow your customers to gain insights? Modern apps with data visualizations built-in have the power to inform decisions in context—for any user and on any device. Thanks to Power BI Embedded, you can now embed data analytics in any app and on one device.

Slides from Formulate Power BI Strategy Seminar

A year ago Microsoft unveiled the new Power BI platform consisting of the PowerBI.com cloud service, Power BI Desktop, and Power BI Mobile. Since then, Prologika has helped organizations of all sizes to plan and adopt Power BI. Packed with features, Power BI supports a dizzying variety of features and integration scenarios but it might be difficult to understand how Power BI fits in your data analytics ecosystem.

Join Prologika and Microsoft for a 3-hour free seminar on Wednesday, August 31th, 8:30 AM -12 PM ET, at the Microsoft Office in Alpharetta, when Teo Lachev (CEO of Prologika) and Brian Jackson (Cloud Solution Architect at Microsoft) share practical knowledge and experience to help you to formulate a Power BI enterprise strategy. If you’re considering Power BI but you’re not sure how it fits within your organizational data strategy, this event is for you.

Key Takeaways
Understand how Power BI changed the way users (information workers, data analysts, BI pros, and developers) gain and share data insights.
Learn 10 areas where Power BI excels compared to other popular BI tools, such as Tableau, Qlik Sense, Sisense, Domo, and others.
Plan a data access strategy for:
Importing data
Connecting live to cloud sources with content packs and solution templates
Connecting live to on-premises data sources
Implementing real-time dashboards
Embedded reporting
Taking a deep dive to learn how Prologika designed and implemented a hybrid architecture solution for a Fortune 50 organization and meet security requirements that prevented exporting data to the cloud
Join in a discussion about other business use cases and gaps between Power BI and other BI products, and find how to address them. Get your questions answered.
You won’t want to miss this educational and engaging event! Please register today as seating is limited at https://prologika.com/event/formulating-a-power-bi-enterprise-strategy/

Microsoft BI 2014 Review

Discusses the state of Microsoft BI Platform at the end of year 2014. I revisit its most important tools and their role in a holistic and modern data analytics environment. Then, for each tool, I discuss its indented use, as well as pros and cons, including self-service and organizational BI, on-premise and cloud, emerging technologies, and how they complement each other in the context of Microsoft BI.

Data Visualizations in Microsoft BI Presentation

Confused about visualization choices for your BI solution? How should you design a dashboard to impress your management? Don’t know what presentation options exist for organizational and self-service BI? Join us to find answers to these questions and share best practices about the visualization tools in the Microsoft BI platform.

Real-time BI with StreamInsight

Filed under: StreamInsight, Real-time BI, Atlanta Code Camp

The slide deck and code for my presentation “Real-time Business Intelligence with StreamInsight” presented on Saturday, 8/24/2013 at Atlanta Code Camp 2013.

Best Practices for Implementing Enterprise BI Solution

Slides from my presentation “Best Practices for Implementing Enterprise BI Solution”.

“Learn best practices to make your organization a center of BI excellence! I’ll walk you through lessons learned during our implementation of an enterprise end-to-end BI solution, which is discussed in the Records Management Firm Saves $1 Million, Gains Faster Data Access with Microsoft BI case study published by Microsoft. Working experience with the dimensional modeling and the Microsoft BI stack is assumed.”

Introducing BISM

At SQL Saturday #89, September 17, 2011

DBI330 – Can Your BI Solution Scale?

Your Business Intelligence solution is ready for prime-time but will it perform well? Join this session to learn techniques for testing the performance and scalability of Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services (SSAS).