Welcome To Our Data Analytics Blog
How to Leverage Biml to Automate SSIS Package Development
Learn what Biml is and how your organization could benefit from leveraging the programming language to automate SSIS package development!
3 Power BI Map Visuals to Bring Your Data to Life
Learn about three powerful Power BI map visuals (Bubble Map, Filled Map, & Shape Map) that will help you create better visualizations for your data.
What is Azure Synapse Analytics?
Azure Synapse Analytics is the next generation of SQL Data Warehouse, re-engineered to combine data warehousing and big data analytics into one service platform.
How to Use Power BI Data Set Quick Insights and Data Subset Quick Insights
We discuss one of the latest Power BI features called Quick Insights, a useful tool that can help data novices become data experts in minutes.
How to Copy Multiple Tables from On-Premise to Cloud in Azure Data Factory
Learn how to copy multiple tables from an on-premise SQL Server database to Azure SQL Data Warehouse.
What is the California Consumer Privacy Act (CCPA)?
The California Consumer Privacy Act (CCPA) is a bill designed to improve the data privacy rights of consumers residing in California.
Back to PASS Summit 2019 – Planning to learn, learn, learn!
Are you heading to PASS Summit 2019? Here’s some of the events we plan to attend while being there!
Data Security Levels and Their Importance in a Data Warehouse
Data security levels are a vital component of successfully securing a data warehouse, particularly when it comes to storing sensitive info like PHI and PII. Learn more in this post!
How to Implement Column Level Security in SQL Server
Column level security (CLS) is a useful tool for limiting access to specific data elements (or database columns) through data obfuscation.
Web Applications and Their Role in Data Security
Learn about the two most common attacks against web applications and what you can do to prevent them from happening to your organization.
PowerShell – How to Display Job Progress
Learn how you can create a PowerShell progress bar per job to monitor and display job progress. We provide the code for you to do so.
Tales from Consulting – Part Two: Software Development Life Cycle (SDLC)
Learn about the highly important software development life cycle (SDLC) in our latest edition of “Tales from Consulting”!
Introducing ‘SharePoint Things’, Our Newest Video Series
Introducing our newest video series, “SharePoint Things.” PowerApps integration with SharePoint Online can be powerful!
Manipulating the Target Table in a SQL SELECT…INTO Statement
The SELECT…INTO statement is a great tool to have in your arsenal if you’re a SQL developer. Learn how to manipulate the target table in such a statement.
Why Data Warehouse Projects Fail
Some data warehouse projects fail – don’t let yours be the next!
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539