Tallan's Technology Blog

Tallan's Top Technologists Share Their Thoughts on Today's Technology Challenges

Category Archive for "Data & Analytics"

Keeping Freight Moving in Denmark with SQL Server 2016

Tallan Partner

Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country’s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40,000 consignments each day throughout Denmark, and businesses from small mom-and-pop operations to factories rely on its services.
The firm handles logistics in a central location, where 200 dispatchers keep an eye on the movement of thousands of trucks and their cargo. Both drivers and dispatchers need the latest information to operate efficiently, so they rely on a data platform based on SQL Server 2016. The storage system includes 160 terabytes of flash memory for fast I/O and high uptimes. Throughout the day, drivers continually scan transactions with PDAs and send shipping information including GPS coordinates to the data platform. Fast access to information is essential. Ulf…

Microsoft Accelerates Modern BI Adoption with Power BI Premium

Tallan Partner

Power BI was first made generally available in July 2015. Since then, Microsoft’s driving vision for Power BI has been to enable users across roles, disciplines and industries to sign up for the service in seconds and get business value by drawing insights from their data within minutes. Microsoft’s relentless focus to drive access to insights at scale has helped Power BI reach more than 200,000 organizations, and the breadth of this global community continues to directly contribute to Power BI’s evolution – to date more than 400 features have been added to the service as the result of input from more than 50,000 users.
Introducing Power BI Premium
Today Microsoft is taking the next step in its commitment to empower people and organizations with access to critical intelligence: introducing Power BI Premium. Power BI Premium builds on the existing Power BI…

Five Ways Microsoft Helps you do Amazing Things with Data in the Cloud

Tallan Partner

1: Build data-driven apps that learn and adapt
Applications show intelligence when they can spot trends, react to events, predict outcomes or recommend choices—often leading to richer customer experiences, improved business process, or addressing issues before they arise. The three key ingredients to creating an intelligent app are:

Ingest data in real time
Query across historical and real-time data
Analyze patterns and make predictions with machine learning

With Azure, you can make your applications intelligent by establishing feedback loops, and applying big data and machine learning techniques to classify, predict, or otherwise analyze explicit and implicit signals. Today, apps for consumers and enterprises can deliver greater customer or business benefit by learning from user behavior and other signals.
Pier 1 Imports launched a mobile-friendly pier1.com, making shopping online easier. It enabled the selection of delivery options like direct shipment, picking up products in the local store,…

The Top 5 Reasons to Upgrade to SQL Server 2016

Tallan Partner

Upgrading your software can be daunting, Microsoft knows. The fast pace of business makes it easy to tell yourself, “I’ll do it later when I have time.” Microsoft gets it! But here are five key reasons to make time to upgrade to SQL Server 2016, which was named DBMS of the Year in 2016 by DBengines.com.

Seamless step-up without rewriting apps. Thanks to November’s SQL Server 2016 Service Pack 1 (SP1), SQL Server now has one programming surface across all editions. If you switch from Express to Standard, or Standard to Enterprise, you don’t have to rework code to take advantage of additional features. Time saved! In addition, the change brings access to innovative features across performance, security, and analytics not previously available in Express or Standard—a great reason to upgrade applications that run on those editions. The Enterprise edition of…

Automatic Deployment and Extraction from CRM Using PowerShell Scripts

Hayden Lee

Recently I was tasked with the task of creating an automatic extraction and importing solution using PowerShell Scripts. To do this I created two files one for export and extracting with the other in charge of pack and importing the solution. I was using the Visual Studio template of CRM Package that comes with the sdk.
Export and Extracting The Solution
First thing I did was implement the export and extraction of the CRM solution. The PowerShell script first exports the solution from the web using a module called Microsoft.Xrm.Data.PowerShell. Then it extracts the downloaded zip into a folder for the correct file structure. A nice thing about using the Microsoft.Xrm.Data.PowerShell dll is the fact it gives you additional CRM commands you can do. For example before downloading the solution it allows you to change the version number of the solution before downloading.

 
As…

Quick Measures Preview

Tallan Partner

Quick measures, a new feature Microsoft released in their April Power BI Desktop update, lets you quickly create new measures based on measures and numerical columns in your table. These new measures become part of your model and can be used in any of your charts, just like manually created DAX calculations. You can also see the underlying DAX, and edit it if you need to tweak the results.
You can create measures based on 19 different calculations across five different categories. Let’s take a look at those five different categories.
Aggregate within category
These calculations let you apply different aggregates at different levels in your data. For example, you can sum revenue up to the month level, and then take an average of that total to display at the year level.

The result would look something like this:

The calculations included in the Aggregate…

Part 2 – Analysis Services Multidimensional: “A duplicate attribute key has been found when processing”

Mark Frawley

Introduction – Part 2

Part 1 of this post focused on the first category of how the Analysis Services Multidimensional (MD) duplicate attribute key error can arise. It reflects the perspective of an atomic attribute – an attribute having no attribute relationships other than with the dimension key attribute.
This post focuses on the second category of this error, which can arise when an attribute does have attribute relationships besides the (required) one with the dimension key attribute.
As is well known, creating attribute relationships is a best practice in Analysis Services MD for improving query performance. The most common reason attribute relationships are created is to support a natural hierarchy – so your data model has to have one for this to arise. The next most common reason is to support attribute properties, such as a sort order – i.e. when the…

Design-Time Properties for Custom SSIS Objects – Part 1 – Intro & Tasks

Matthew Gajdosik

Managing the editable properties of your custom objects in SQL Server Integration Services (SSIS) is a great way to improve their usability, but how can you? By properties, I mean the common fields exposed on the Properties tool window in Visual Studio, any time you’re working with a visual designer, and which you’ve probably used any time you wanted to make a precise change, or a quick change.
In SSIS, you can create your own class to handle all of the following types:

Data Flow / Pipeline Components
Control Flow Tasks
Connection Managers
Log Providers
For Each Enumerators (for the for each loop task)

For the most part, these custom classes can be directly modified when editing SSIS packages in Visual Studio, and so anything properties you expose on the class can be edited right from Visual Studio without opening up any new UIs. For simple objects especially, these can…

How Microsoft Treasury uses Power BI

Tallan Partner

 
The Microsoft Treasury group manages $158 billion in assets, including cash and investments, account receivable, equity, and other investments. They act as an in-house bank for operations in over 190 countries, monitor thousands of bank accounts, and provide just-in-time cash management on a global basis. With a preview this large, Microsoft Treasury relies on vast amount of data in order to make fast, accurate, and actionable decisions to keep their operations running smoothly.
In the past, Treasury used a combination of Excel, PowerPoint, and third-party services to analyze and present their data, but Corporate VP, Treasurer George Zinn saw the future in the integration of a different product: Microsoft Power BI.
Power BI is a cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information, and share insights. It features easy drag-and-drop…

Microsoft’s SQL Platform Continues to Lead the Market with Advanced Data Security

Tallan Partner

Securing customer data while maintaining the highest levels of privacy have always been top priorities for Microsoft and the SQL organization. As a result, SQL Server, which also powers Azure SQL Database and Azure SQL Data Warehouse, continues to be one of the most secure Relational Database Management Systems (RDBMS) on the market.[1]
At the RSA Conference last year, Microsoft talked about their commitment to security and privacy. Microsoft wants to share a few examples of industry-leading security features they shipped since then and update you on their plans to deliver the highest levels of security across the SQL Database product lineup.
Announcing the April general availability of Azure SQL Database Threat Detection for proactive monitoring and alerting of suspicious database activities and potential vulnerabilities.
Using machine learning, SQL Database Threat Detection continuously monitors and profiles application behavior, and detects suspicious database activities…

\\\