What Not To Do With Power BI

I read learned it’s more valuable of a lesson when something doesn’t work out rather than when everything is going in the right direction. For this reason, I felt it was appropriate to create a post on bad practices rather than best practices when it comes to Power BI for an end-user to reflect upon and see what not to do when using Power BI.

by Jeff Lipkowitz Oct 12, 2021

Using Custom Themes In Power BI

An organization’s data needs often span beyond getting user-critical metrics and actions defined and then built into an appropriate report or dashboard. Marketing often wants a consistent look and feel associated with reports and dashboards to keep all customer-facing material consistent.

This article is for the Power BI user that wants to take there analytics polish to the next level. 

by Jeff Lipkowitz Jul 14, 2021

Using DAX Studio To Jump Start Your Data Dictionary

In the world of analytics, understanding and being able to define your data is king in any data project. Organizations often focus on the early stage around getting systems set up and the technology behind the data, but they easily lose focus on the metrics and key information the business needs and the process to govern their data. 

by Jeff Lipkowitz Jun 22, 2021

NO ETL SYSTEM, NO PROBLEM

Often organizations work with Excel files or SharePoint lists to support business processes. When the way an organization manages its business process using these tools fundamentally changes, the IT solution supporting the process changes as a result.

In this blog post will talk about an approach to load data in to Azure SQL with out using a ETL tool. 

by Jeff Lipkowitz Jun 8, 2021

How to Secure a Synapse Workspace with Active Directory groups 

Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems. Azure Synapse brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, Cosmos DB, and Azure ML.  

In this blog we will show how we can use Active Directory Groups to secure Synapse

by Jeff Lipkowitz May 27, 2021

Azure ML How to Get Your Data Moving Using Azure Data Factory

HOW TO DESIGN AN AZURE MACHINE LEARNING SOLUTION  
 
When designing an Azure machine learning solution, one of the most critical decisions is understanding how any Azure machine learning solution pipeline will be executed. In this blog post will talk about how to use datafactory and Azure ML

by Jeff Lipkowitz May 26, 2021