Setting up vs code for Remote Development step by step In part one of this series, we showed you how to configure a Windows 2019 EC2 instance to run an OpenSSH Server to pave the way for secure, ...
Setting up VS Code for Remote Development with Source Control (Part 2)
Configuring SSH for Public Key Authentication In part one of this series, we showed you how to configure a Windows 2019 EC2 instance to run an OpenSSH Server to pave the way for secure, remote ...
Setting up VS Code for Remote Development with Source Control (Part 1)
Setting up a Remote Development Environment with OpenSSH Server (sshd or daemon for you Linux Folks) COVID has revolutionized the way we think about work. Setting up a remote development ...
Right Sizing Your Power BI Gateway on AWS
This guide is about the challenges and obstacles you might run into if you try to scale an Amazon EC2 Instance running Power BI’s OnPremise’s gateway. It all comes down to the current limitations in ...
Creating Power BI Custom Visuals
Sometimes dashboard/reporting projects call for data visualizations that are not part of the package. Power BI has a lot of visualizations out of the box (OOB) and in AppSource, but when they aren’t ...
My Power BI report is too slow. What tools and techniques should I use?
Is your Power BI report too slow? In my last post, I focused on Power BI Report performance problems caused by memory issues, and the tools available to diagnose those issues. In this post, I will ...
Are Your Power BI Performance Issues Due To High Memory Consumption?
Could your Power BI Document be consuming too much Memory? Power BI performance is one of the key factors affecting satisfaction by business users. We'll examine memory consumption by Power BI ...
Power BI Parameters – How to Use & Update Parameters in the Power BI Service
Power BI parameters are one of the most requested features in Power BI. Parameters are generally used in reports and dashboards to make them more dynamic. Creative report developers can use parameters ...
Power BI Tips: How To Increase The Number of Rows Exported to Excel
Currently Power BI has an export limit: 30,000 rows when you export to CSV and 150,000 when you export to Excel. There are a lot of complaints about this limit. In many cases the limit is a deal ...
Snowflake Cloud Data Warehouse Now on Microsoft Azure
Snowflake cloud data warehouse now brings its platform to Microsoft Azure. This is another choice for Microsoft-friendly enterprises as more companies move their data and analytics workloads to the ...
DesignMind Awarded AWS Cloud Consulting Partner
The DesignMind team achieved an important milestone this fall. We became a Standard AWS Cloud Consulting Partner. Now you'll see us listed on the AWS website in their Partner Finder Program. To ...
Power BI Data Modeling Tips for Developers and Analysts
Data Modeling is an important skill for Power BI Developers and Analysts to master. Power BI data modeling tips are often overlooked. A well-designed data model will result in: Better ...
Where is Microsoft taking Power BI?
Where is Microsoft taking Power BI? At Inspire 2018, Microsoft's Worldwide Partner Conference in July, Microsoft highlighted the investments they're making in Power BI in FY19. There are two areas of ...
Qubole Snowflake Partnership Opens Possibilities for Faster, Better Insights
The Qubole Snowflake partnership was just announced by our big-data-as-a-service partner, Qubole. The partnership with Snowflake, a highly scalable cloud-based data warehouse, offers customers of both ...
MDM Security Permissions To Safeguard Data
Your data is dependent on those who have access to it, so you need to choose which users have access to data based on task relevancy. That's where MDM Security Permissions come in. In a nutshell, you ...
MDM Business Rules to Ensure Accuracy
Leveraging MDM Business Rules For Accuracy and Clarity MDM users make mistakes. Surprised? The truth is that humans are always the weakest link in any data-management system. In fact, human error ...
MDM User Interface Design Best Practices
A useful Master Data Management ecosystem needs to have all the elements right to be effective. An intuitive, concise and attractive MDM user interface make data interaction easy and encourages use - ...
How To Standardize Reports with Power BI Themes and Templates
Power BI Themes and Templates Can Ramp Up Your Data Analysis Data is a crucial asset that businesses of every size must leverage in today’s competitive market.The data itself is simply a raw ...
Using Power BI To Extract the Hidden Value in Your Data
Using Power BI may be even more valuable than you imagined. Just think about how much of the data at your organization gets used. What percentage is really used to analyze, evaluate, and help drive ...
Power BI Dashboard In An Hour
Power BI Dashboard In An Hour is a hands-on, high-level introduction to Power BI. In just a an hour (or two) you'll get hands-on experience using Power BI, including building visualizations and a ...
How To Use Power BI to Enhance Data Exploration
Microsoft’s recent feature additions to Power BI brings smarter insights, greater efficiency, and improved flexibility in your information dashboards for the enterprise. Yet many businesses aren't ...
How to Step Up Power BI Visualization for Your Business in 2017
Are You Taking Full Advantage of Power BI Visualization? Microsoft Power BI has helped revolutionize business intelligence across the enterprise. Yet some companies still aren’t taking full advantage ...
Hortonworks Big Data Analytics
Developer Talk: Why Hortonworks? Five Distinguishing Features of Hortonworks Big Data Analytics When it comes to Hadoop distributions, developers have a multitude of choices, including Cloudera, ...
Big Data Analytics Tools We Like
Hortonworks for Hadoop – The Open Source Leader Cloudera, Hortonworks, and MapR are among the choices of Hadoop distributions for supporting big data analytics. At DesignMind, our team of big data ...
Data Visualization with Power BI and R Visuals
A Look at JetBlue's Most Profitable and Fuel Efficient Routes Data Visualization with Power BI and R Visuals has significantly stepped up the sophistication of data visualization. On July 5, 2016, ...
Our Top Four Power BI Features
Power BI Features You Shouldn't Miss At DesignMind, we’re excited about Power BI. Since 2012, we've lived through the Power BI evolution, from Sharepoint, to Excel, and now as Power BI Desktop and ...
Three Common Master Data Problems You Never Knew You Had
Master Data is often overlooked Master Data Management (MDM) should be an integral part of every company’s Business Intelligence Roadmap, but it's often overlooked. Data Platform, ETL, and BI Tools ...
Analysis Services Tabular Process Optimization
How to use Analysis Services Tabular to get near real-time updates for your Power BI dashboards Analysis Services provides three different approaches for creating a business intelligence semantic ...
Big Data Visualization with Tableau Online
With all the attention on the four V’s of Big Data – Volume, Velocity, Variety and Veracity, there's a V that doesn't get enough credit: Visualization. It's true that value from big data lies in ...
Power BI File Management with OneDrive
Best Practices for Publishing Interactive Reports and Dashboards on PowerBI.com One of the most common issues that we’ve seen with the growth in Power BI implementations is the challenge of managing ...
Choosing a Data Lake Storage System
Data Lake Storage System: Which One Should You Use? When you create a Data Lake, one of the most overlooked questions is, "What storage technology should back the lake?" Most companies just go with ...
The Shopping Beacon and How It’s Changing Retail
The Shopping Beacon: Your New Best Friend The shopping beacon is changing how you shop. Imagine you're looking looking at a smartwatch in the store window, and you get a text with 10% off on the ...
What is Power BI and Schedule Data Refresh?
Microsoft’s much anticipated General Availability release of Microsoft Power BI is here, and with it a lot of new and exciting features of both PowerBI.com and the free Power BI Desktop development ...
Microsoft SSAS: Why It Should Be Part Of Your Big Data Game Plan
While many organizations are using Hadoop for big data warehousing, it’s also worth considering a reliable alternative: Microsoft SSAS Here in Silicon Valley, you can’t have a cup of coffee without ...
Power BI: 5 Things You Need to Know Now
Power BI has been out for a while. It's a reporting solution that Microsoft has developed, enabling analysts, BI developers, and power users to create ad hoc analysis in the most popular BI tool in ...
Big Data: How To Do It Right
Big Data Planning and Research Pays Off If you’re beginning your first foray into analyzing your organization’s Big Data, you need to spend some time thinking about the big picture. The payoffs of ...
Hiring a Data Science Team: Types of Data Scientists
Hiring a new member to your team is always a daunting task. Now combine that with looking to fill "The Sexiest Job of the Century", Data Scientist, and you have quite the conundrum on your ...
Hadoop Speeds Data Delivery at Bloomberg
Many organizations are adopting Hadoop as their data platform because of two fundamental issues: They have a lot of data that they need to store, analyze and make sense of, on the order of 10s of ...
Joy Mundy of the Kimball Group
Joy Mundy of the renowned IT consulting firm Kimball Group focuses on Data Warehouse and Business Intelligence solutions. She spoke at SQLSaturday Silicon Valley on designing dimensional ...